<?xml version = '1.0' encoding = 'UTF-8'?>
<HBRRepo><variables/><rulesets/><rules/><components><component type="script" id="3" name="Monthly_Trends" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Monthly_Trends</property><property name="seeded">true</property><script type="calcscript">If("OFS_Trend"->"BegBalance"==1)						
	if(@isuda("Account","CalcRound"))					
		OFS_Calculated = @Round(@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , &amp;OEP_StartMnth:&amp;OEP_CurMnth)*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
	else					
		OFS_Calculated =@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , &amp;OEP_StartMnth:&amp;OEP_CurMnth)*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
	endif					
elseif("OFS_Trend"->"BegBalance"==2)						
	if(@isuda("Account","CalcRound"))					
		OFS_Calculated =@Round(("OEP_Actual"->&amp;OEP_CurMnth->&amp;OEP_CurYr->"OFS_Load")*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
	else					
		OFS_Calculated = ("OEP_Actual"->&amp;OEP_CurMnth->&amp;OEP_CurYr->"OFS_Load")*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
	endif					
						
elseif("OFS_Trend"->"BegBalance"==4)						
	if(@isuda("Account","CalcRound"))					
		OFS_Calculated = @Round(@avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("YearTotal",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
	else					
		OFS_Calculated = @avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("YearTotal",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
	endif					
elseif("OFS_Trend"->"BegBalance"==5)						
	if(@isuda("Account","CalcRound"))					
		OFS_Calculated = @Round(("OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr)*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
	else					
		OFS_Calculated = ("OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr)*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
	endif					
elseif("OFS_Trend"->BegBalance==12)						
	OFS_Calculated =#missing;					
elseif("OFS_Trend"->BegBalance==#missing and "OFS_Adjustment (+/-)"&lt;>#missing)										
	OFS_Calculated=0;
    OFS_Calculated=#missing;					
					
</script></component><component type="script" id="4" name="Plan_Only_Trends" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Plan_Only_Trends</property><property name="seeded">true</property><script type="calcscript">elseif("OFS_Trend"->"BegBalance"==6)
			if(@isuda("Account","CalcRound"))
				"OFS_Calculated" = @Round(@avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),@relative("YearTotal",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
			else
				"OFS_Calculated" = @avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),@relative("YearTotal",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
	endif                
	                
elseif("OFS_Trend"->"BegBalance"==8)
			if(@isuda("Account","CalcRound"))
				"OFS_Calculated" = @Round(@prior("OEP_Forecast"->"OFS_Total Plan",1, @LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
			else
				"OFS_Calculated" = @prior("OEP_Forecast"->"OFS_Total Plan",1, @LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
			endif
elseif("OFS_Trend"->"BegBalance"==10)
				if(@isuda("Account","calcRound"))
					"OFS_Calculated" = @Round(@prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
				else
					"OFS_Calculated" = @prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
	endif</script></component><component type="script" id="2" name="Plan_Only_Weekly" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Plan_Only_Weekly</property><property name="seeded">true</property><script type="calcscript">elseif("OFS_Trend"->"BegBalance"==6)
			if(@prior("TP-Weeks",1,@levmbrs(Years,0))==52)
				if(@isuda("Account","CalcRound"))
					"OFS_Calculated" = @Round(@avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),OEP_W1:OEP_W52)*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
				else
					"OFS_Calculated" = @avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),OEP_W1:OEP_W52)*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
				endif        
			else
				if(@isuda("Account","CalcRound"))
					"OFS_Calculated" = @Round(@avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),@relative("OEP_Weekly Plan",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
				else
					"OFS_Calculated" = @avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),@relative("OEP_Weekly Plan",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
				endif   
			 endif
elseif("OFS_Trend"->"BegBalance"==8)	
			if(@isuda("Account","CalcRound"))
				"OFS_Calculated" = @Round(@prior("OEP_Forecast"->"OFS_Total Plan",1, @LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
			else
				"OFS_Calculated" = @prior("OEP_Forecast"->"OFS_Total Plan",1, @LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
			endif
elseif("OFS_Trend"->"BegBalance"==10)
			if(@isuda("Account","calcRound"))
				"OFS_Calculated" = @Round(@prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
			else
				"OFS_Calculated" = @prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
			endif</script></component><component type="script" id="5" name="Qrtly_Trends" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Qrtly_Trends</property><property name="seeded">true</property><script type="calcscript">If("OFS_Trend"->"BegBalance"==1)										
		if(@isuda("Account","CalcRound"))	
        	if(@isuda("Account","Flow"))
				"OFS_Calculated" = @Round((@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , &amp;OEP_StartMnth:&amp;OEP_CurMnth))*"PeriodsInQtr"*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
            else
            	"OFS_Calculated" = @Round((@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , &amp;OEP_StartMnth:&amp;OEP_CurMnth))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
            endif
		else
        	if(@isuda("Account","Flow"))
				OFS_Calculated =(@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , &amp;OEP_StartMnth:&amp;OEP_CurMnth))*"PeriodsInQtr"*(1+"OFS_% Increase/(Decrease)"->"BegBalance");			
            else
            	OFS_Calculated =(@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , &amp;OEP_StartMnth:&amp;OEP_CurMnth))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");		
            endif
		endif									
elseif("OFS_Trend"->"BegBalance"==2)										
		if(@isuda("Account","CalcRound"))
        	if(@isuda("Account","Flow"))
				OFS_Calculated =@Round((("OEP_Actual"->&amp;OEP_CurMnth->&amp;OEP_CurYr->"OFS_Load")*"PeriodsInQtr")*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));	
            else
            	OFS_Calculated =@Round((("OEP_Actual"->&amp;OEP_CurMnth->&amp;OEP_CurYr->"OFS_Load"))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));	
            endif
		else	
        	if(@isuda("Account","Flow"))
				OFS_Calculated = (("OEP_Actual"->&amp;OEP_CurMnth->&amp;OEP_CurYr->"OFS_Load")*"PeriodsInQtr")*(1+"OFS_% Increase/(Decrease)"->"BegBalance");	
            else
            	OFS_Calculated = (("OEP_Actual"->&amp;OEP_CurMnth->&amp;OEP_CurYr->"OFS_Load"))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");	
            endif
		endif									
	elseif("OFS_Trend"->"BegBalance"==4)										
		if(@isuda("Account","CalcRound"))		
        	if(@isuda("Account","Flow"))
				OFS_Calculated = @Round((@avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("YearTotal",0))*"PeriodsInQtr")*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));		
            else
           		OFS_Calculated = @Round((@avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("YearTotal",0)))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));	
            endif
		else	
        	if(@isuda("Account","Flow"))
				OFS_Calculated = (@avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("YearTotal",0))*"PeriodsInQtr")*(1+"OFS_% Increase/(Decrease)"->"BegBalance");	
            else
            	OFS_Calculated = (@avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("YearTotal",0)))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
            endif
		endif												
	elseif("OFS_Trend"->"BegBalance"==10)										
		if(@prior("OEP_Qrtly Plan",1,@levmbrs("Years",0))&lt;>#Missing)									
			if(@isuda("Account","CalcRound"))								
				@Round(@Prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));							
			else								
				@Prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");							
			endif								
		else									
			if(@isuda("Account","CalcRound"))								
				if(@ismbr("Qtrly 1"))							
					@Round(@Prior("OFS_Total Plan"->"Q1",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));						
				elseif(@ismbr("Qtrly 2"))							
					@Round(@Prior("OFS_Total Plan"->"Q2",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));						
				elseif(@ismbr("Qtrly 3"))							
					@Round(@Prior("OFS_Total Plan"->"Q3",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));						
				elseif(@ismbr("Qtrly 4"))							
					@Round(@Prior("OFS_Total Plan"->"Q4",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));						
				endif							
			else								
				if(@ismbr("Qtrly 1"))							
					@Prior("OFS_Total Plan"->"Q1",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");						
				elseif(@ismbr("Qtrly 2"))							
					@Prior("OFS_Total Plan"->"Q2",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");						
				elseif(@ismbr("Qtrly 3"))							
					@Prior("OFS_Total Plan"->"Q3",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");						
				elseif(@ismbr("Qtrly 4"))							
					@Prior("OFS_Total Plan"->"Q4",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");						
				endif							
			endif								
											
		endif									
	elseif("OFS_Trend"->BegBalance==12)										
				OFS_Calculated=#missing;							
	elseif("OFS_Trend"->BegBalance==#missing and "OFS_Adjustment (+/-)"&lt;>#missing)																
				OFS_Calculated=0;
                OFS_Calculated=#missing;							
	endif										

</script></component><component type="script" id="1" name="Weekly_Trends" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Weekly_Trends</property><property name="seeded">true</property><script type="calcscript">If("OFS_Trend"->"BegBalance"==1)						
	if(@isuda("Account","CalcRound"))					
		"OFS_Calculated"=@Round(@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , OEP_W1:&amp;OEP_CurWeek)*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
	else					
		"OFS_Calculated"=@AVGRANGE(SKIPNONE , "OEP_Actual"->"OFS_Load"->&amp;OEP_CurYr , OEP_W1:&amp;OEP_CurWeek)*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
	endif					
elseif("OFS_Trend"->"BegBalance"==2)						
	if(@isuda("Account","CalcRound"))					
		"OFS_Calculated"=@Round(("OEP_Actual"->&amp;OEP_CurWeek->&amp;OEP_CurYr->"OFS_Load")*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
	else					
		"OFS_Calculated"=("OEP_Actual"->&amp;OEP_CurWeek->&amp;OEP_CurYr->"OFS_Load")*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
	endif					
elseif("OFS_Trend"->"BegBalance"==4)
	if("TP-Weeks"->&amp;OEP_PriorYr==52)        
		if(@isuda("Account","CalcRound"))	 		  
			"OFS_Calculated"= @Round(@avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,OEP_W1:OEP_W52)*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
		else					
			"OFS_Calculated"= @avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,OEP_W1:OEP_W52)*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
		endif
	else       
		if(@isuda("Account","CalcRound"))	 		  
			"OFS_Calculated"= @Round(@avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("OEP_Weekly Plan",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
		else					
			"OFS_Calculated"= @avgrange(skipnone,"OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr,@relative("OEP_Weekly Plan",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
		endif
	endif
elseif("OFS_Trend"->"BegBalance"==5)						
	if(@isuda("Account","CalcRound"))					
		"OFS_Calculated"= @Round(("OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr)*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
	else					
		"OFS_Calculated"= ("OEP_Actual"->"OFS_Load"->&amp;OEP_PriorYr)*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
	endif					
elseif("OFS_Trend"->BegBalance==12)						
	"OFS_Calculated"=#missing;					
elseif("OFS_Trend"->BegBalance==#missing and "OFS_Adjustment (+/-)"&lt;>#missing)										
	OFS_Calculated=0;
    OFS_Calculated=#missing;					</script></component><component type="script" id="6" name="Yearly_Trends" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Yearly_Trends</property><property name="seeded">true</property><script type="calcscript">if("OFS_Trend"->"BegBalance"==10)							
	if(@prior("OEP_Yearly Plan"->"OFS_Total Plan",1,@levmbrs("Years",0))&lt;>#Missing)						
		if(@isuda("Account","CalcRound"))					
			OFS_Calculated=@Round(@Prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
		else					
			OFS_Calculated=@Prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
		endif					
	elseif(@prior("OEP_Qrtly Plan"->"OFS_Total Plan",1,@levmbrs("Years",0))&lt;>#Missing)						
		if(@isuda("Account","CalcRound"))					
			OFS_Calculated=@Round(@Prior("OFS_Total Plan"->"Qrtly Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
		else					
			OFS_Calculated=@Prior("OFS_Total Plan"->"Qrtly Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
		endif					
	elseif(@prior("YearTotal"->"OFS_Total Plan",1,@levmbrs("Years",0))&lt;>#Missing)						
		if(@isuda("Account","CalcRound"))					
			OFS_Calculated=@Round(@Prior("OFS_Total Plan"->"YearTotal",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));				
		else					
			OFS_Calculated=@Prior("OFS_Total Plan"->"YearTotal",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");				
		endif					
	endif						
							
elseif("OFS_Trend"->BegBalance==12)							
			OFS_Calculated=#missing;				
elseif("OFS_Trend"->BegBalance==#missing and "OFS_Adjustment (+/-)"&lt;>#missing)	
			OFS_Calculated=0;
			OFS_Calculated=#missing;				
endif							


</script></component></components><templates><template custom="yes" id="1" name="OFS_Prepare Plan_T" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">OFS_Prepare Plan_T</property><property name="seeded">true</property><statement seq="1" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">dCurrency eq Is Not Empty</property><property name="display_width">3</property><property name="Tile_Key">x1y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Application</user_inp></expression><expression seq="2"><user_inp>Is Simple Currency</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-101" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">strCurrencyFix = ,@relativ...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>strCurrencyFix</user_inp></destination><expression><user_inp>,@relative({Currency},0)</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="2" type="component" kind="formula" name=""><component type="formula" id="-102" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Rev Source Flex1 = @PLANDI...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>Rev Source Flex1</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Product")</user_inp></expression></formula><formula><destination><user_inp>Rev Source Flex2</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Services")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex1</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Cost Center")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex2</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Channel")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex3</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Funding Segment")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex4</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "RevenueDriver4")</user_inp></expression></formula></conditionblock></formulae></component></statement><statement seq="3" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Source Flex1 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x5y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Source Flex1</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-104" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevSrc1_Fix = Fix(@relativ...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevSrc1_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Product",0))</user_inp></expression></formula><formula><destination><user_inp>RevSrc1_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevSrc1_Agg</user_inp></destination><expression><user_inp>Agg("Product");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="4" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Source Flex2 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x8y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Source Flex2</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-106" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevSrc2_Fix = Fix(@relativ...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevSrc2_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Services",0))</user_inp></expression></formula><formula><destination><user_inp>RevSrc2_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevSrc2_Agg</user_inp></destination><expression><user_inp>Agg("Services");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="5" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex1 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x11y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex1</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-108" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver1_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver1_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Cost Center",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver1_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver1_Agg</user_inp></destination><expression><user_inp>Agg("Cost Center");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="6" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex2 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x14y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex2</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-110" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver2_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver2_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Channel",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver2_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver2_Agg</user_inp></destination><expression><user_inp>Agg("Channel");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="7" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex3 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x17y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex3</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-112" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver3_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver3_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Funding Segment",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver3_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver3_Agg</user_inp></destination><expression><user_inp>Agg("Funding Segment");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="8" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex4 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x20y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex4</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-114" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver4_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver4_Fix</user_inp></destination><expression><user_inp>Fix(@relative("RevenueDriver4",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver4_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver4_Agg</user_inp></destination><expression><user_inp>Agg("RevenueDriver4");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="9" type="component" kind="script" name=""><component type="script" id="-115" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">set updatecalc off;
set aggmis</property><script type="calcscript">FIX (OEP_Working [strCurrencyFix])
Fix(@relative({Entity},0))

[RevSrc1_Fix]
[RevSrc2_Fix]
[RevDriver1_Fix]
[RevDriver2_Fix]
[RevDriver3_Fix]
[RevDriver4_Fix]
	Fix(@remove(@relative("Account",0),@list(@relative("System Members",0),@relative("OFS_Cross Module Integration",0))))
 
"OFS_Calculated"(
  @calcmode(block);
  @calcmode(bottomup);
if("OFS_Trend"->"BegBalance" &lt;>#Missing)

</script></component></statement><statement seq="10" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_width">3</property><property name="Tile_Key">x21y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>@DIMMEMBER(Period, OEP_W53)</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-117" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>WKScript</user_inp></destination><expression><user_inp>(@ismbr(@remove(@relative("OEP_Weekly Plan", 0),"OEP_W53"))) or ("TP-Weeks" == 53 and @ismbr(@relative("OEP_Weekly Plan", 0)))</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="11" type="component" kind="formula" name=""><component type="formula" id="-118" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Weekly = @DIMMEMBER("Perio...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>Weekly</user_inp></destination><expression><user_inp>@DIMMEMBER("Period", "OEP_Weekly Plan")</user_inp></expression></formula><formula><destination><user_inp>IsWeeklyEnabled</user_inp></destination><expression><user_inp>@COMPARE([Weekly], "OEP_Weekly Plan", "true")</user_inp></expression></formula></conditionblock></formulae></component></statement><statement seq="12" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">IF</property><property name="display_width">3</property><property name="Tile_Key">x25y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>IsWeeklyEnabled</user_inp></expression><expression seq="2"><user_inp>True</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="script" name=""><component type="script" id="-120" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="caption">Weekly</property><property name="display_label">Weekly</property><script type="calcscript">if(Not(@ismbr(&amp;OEP_QrtlyPlanStart:&amp;OEP_QrtlyPlanEnd) or @ismbr(&amp;OEP_YrlyPlanStart:&amp;OEP_YrlyPlanEnd)))
	if([WKScript])     	     
		%Script(name:="Weekly_Trends")		
		%Script(name:="Plan_Only_Weekly")
	endif	
	elseif(@ismbr(@relative(YearTotal,0)))

        %Script(name:="Monthly_Trends")             
        %Script(name:="Plan_Only_Trends")       
    	endif /* this endif is needed for the trend */
    endif
elseif (@ismbr(&amp;OEP_QrtlyPlanStart:&amp;OEP_QrtlyPlanEnd)) 	
        if (@ismbr(@relative("OEP_Qrtly Plan", 0))) 
		%Script(name:="Qrtly_Trends")
    endif

elseif (@ismbr(&amp;OEP_YrlyPlanStart:&amp;OEP_YrlyPlanEnd))
        if (@ismbr("OEP_Yearly Plan")) 
       		 %Script(name:="Yearly_Trends")
        endif  
	
	endif
endif
)
;
endfix
  
  	Fix(OFS_Calculated)
    	calc dim("Account");
    endfix
 
[RevDriver4_EndFix]
[RevDriver3_EndFix]
[RevDriver2_EndFix]
[RevDriver1_EndFix]
[RevSrc2_EndFix]
[RevSrc1_EndFix]
		
Endfix  
EndFix</script></component></statement></then><else><statement seq="1" type="component" kind="script" name=""><component type="script" id="-121" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="caption">Non Weekly</property><property name="display_label">Non Weekly</property><script type="calcscript">if (@ismbr(&amp;OEP_PlanStartYr:&amp;OEP_PlanEndYr))

    if(@ismbr(@relative(YearTotal,0)))
        %Script(name:="Monthly_Trends")             
        %Script(name:="Plan_Only_Trends")   
    
    	endif /* this endif is needed for the trend */
	endif

elseif (@ismbr(&amp;OEP_QrtlyPlanStart:&amp;OEP_QrtlyPlanEnd)) 	
	If(Not(@ismbr("No Year")))		
        if (@ismbr(@relative("OEP_Qrtly Plan", 0))) 
		%Script(name:="Qrtly_Trends")
		endif
	endif        
	       
elseif (@ismbr(&amp;OEP_YrlyPlanStart:&amp;OEP_YrlyPlanEnd))
	If(Not(@ismbr("No Year")))		
        if (@ismbr("OEP_Yearly Plan")) 
        %Script(name:="Yearly_Trends")
        endif  
endif
endif
endif

 )
 ;
    endfix
  
  	Fix(OFS_Calculated)
    	calc dim("Account");
    endfix
 
[RevDriver4_EndFix]
[RevDriver3_EndFix]
[RevDriver2_EndFix]
[RevDriver1_EndFix]
[RevSrc2_EndFix]
[RevSrc1_EndFix]

Endfix  
EndFix</script></component></statement></else></if></statement><template_wizard><wizard_step name="Inputs" seq="0"/></template_wizard><template_prompts><restricted_prompt name="Application Type" type="Application Type" isPrompt="no"><property name="is_system">true</property><restricted_prompt_item><property name="prompt">Is Generic</property><property name="value">GENERAL</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is PFP</property><property name="value">PROJECT</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is PSB</property><property name="value">PSB</property></restricted_prompt_item></restricted_prompt><restricted_prompt name="Application" type="Application" isPrompt="no"><property name="is_system">true</property><value>Is Single Currency</value><restricted_prompt_item><property name="prompt">Is Multi Currency</property><property name="value">multi</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is Single Currency</property><property name="value">single</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is Simple Currency</property><property name="value">simple</property></restricted_prompt_item></restricted_prompt><template_slice_prompt name="UpperPOV" type="Member Range" isPrompt="false"><property name="is_system">true</property></template_slice_prompt><restricted_prompt name="Essbase Mode" type="Essbase Mode" isPrompt="no"><property name="is_system">true</property><restricted_prompt_item><property name="prompt">Is Hybrid</property><property name="value">Hybrid</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is NonHybrid</property><property name="value">NonHybrid</property></restricted_prompt_item></restricted_prompt><template_prompt name="Rev Source Flex1" type="String" isPrompt="false"/><template_prompt name="Rev Source Flex2" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex1" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex2" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex3" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex4" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="RevSrc1_Fix" type="String" isPrompt="false"/><template_prompt name="RevSrc1_EndFix" type="String" isPrompt="false"/><template_prompt name="RevSrc1_Agg" type="String" isPrompt="false"/><template_prompt name="RevSrc2_Fix" type="String" isPrompt="false"/><template_prompt name="RevSrc2_EndFix" type="String" isPrompt="false"/><template_prompt name="RevSrc2_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver1_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver1_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver1_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver2_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver2_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver2_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver3_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver3_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver3_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver4_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver4_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver4_Agg" type="String" isPrompt="false"/><template_prompt name="mPeriod" type="Members" isPrompt="true"><property name="dim_type_limit">Period</property><property name="dimension_limit">both</property><property name="prompt_text">Enter Period</property></template_prompt><template_prompt name="mYear" type="Members" isPrompt="true"><property name="dim_type_limit">Year</property><property name="dimension_limit">both</property><property name="prompt_text">Enter Years</property></template_prompt><template_prompt name="mVersion" type="Member" isPrompt="true"><property name="dim_type_limit">Version</property><property name="dimension_limit">both</property><property name="prompt_text">Enter Version</property></template_prompt><template_prompt name="strEndFix" type="String" isPrompt="false"><value>EndFix</value></template_prompt><template_prompt name="dCurrency" type="Dimension" isPrompt="false"><value>Currency</value><dimension name="Currency"/></template_prompt><template_prompt name="strCurrencyFix" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Weekly" type="String" isPrompt="false"><property name="dim_type_limit">Period</property><property name="dimension_limit">both</property></template_prompt><template_prompt name="IsWeeklyEnabled" type="Boolean" isPrompt="false"/><template_prompt name="WKScript" type="String" isPrompt="false"><value>@ismbr(@relative("OEP_Weekly Plan", 0))</value></template_prompt></template_prompts></template></templates></HBRRepo>